<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="utf-8">
    <meta name="applicable-device" content="pc,mobile">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0">
    <link rel="shortcut icon" href="https://i.veimoz.com/favicon.ico">
    <link rel="stylesheet" href="../okle/css/bootstrap-reboot.min.css">
    <link rel="stylesheet" href="../okle/css/bootstrap-grid.min.css">
    <link rel="stylesheet" href="../okle/css/iconfont.css">
    <link rel="stylesheet" href="../okle/css/main.css">
    <title>如何删除重复项只保留一个 - 使用SQL语句 - 微兔设计</title>
    <script>themeUrl = "https://www.veimoz.com/usr/themes/spzac";</script>
    <meta property="og:title" content="如何删除重复项只保留一个 - 使用SQL语句">
    <meta property="og:type" content="article">
    <meta property="og:url" content="https://www.veimoz.com/2058"/>
    <meta property="og:description" content="在处理数据库中的重复数据时，有时我们需要删除重复项，只...">
    <meta name="description"
          content="在处理数据库中的重复数据时，有时我们需要删除重复项，只保留一个副本。通过使用SQL语句，我们可以轻松地实现这个目标。在本文中，我们将介绍一种常见的方法来删除重复项，以便您可以应用于您的数据库。步..."/>
    <meta name="keywords" content="sql"/>
    <meta name="generator" content="Typecho 1.1/17.10.30"/>
    <meta name="template" content="spzac"/>
    <link rel="alternate" type="application/rss+xml"
          title="如何删除重复项只保留一个 - 使用SQL语句 &raquo; 微兔设计 &raquo; RSS 2.0"
          href="https://www.veimoz.com/feed/2058"/>
    <link rel="alternate" type="application/rdf+xml"
          title="如何删除重复项只保留一个 - 使用SQL语句 &raquo; 微兔设计 &raquo; RSS 1.0"
          href="https://www.veimoz.com/feed/rss/2058"/>
    <link rel="alternate" type="application/atom+xml"
          title="如何删除重复项只保留一个 - 使用SQL语句 &raquo; 微兔设计 &raquo; ATOM 1.0"
          href="https://www.veimoz.com/feed/atom/2058"/>
    <script type="text/javascript">
        (function () {
            window.TypechoComment = {
                dom: function (id) {
                    return document.getElementById(id);
                },

                create: function (tag, attr) {
                    var el = document.createElement(tag);

                    for (var key in attr) {
                        el.setAttribute(key, attr[key]);
                    }

                    return el;
                },

                reply: function (cid, coid) {
                    var comment = this.dom(cid), parent = comment.parentNode,
                        response = this.dom('respond-post-2058'), input = this.dom('comment-parent'),
                        form = 'form' == response.tagName ? response : response.getElementsByTagName('form')[0],
                        textarea = response.getElementsByTagName('textarea')[0];

                    if (null == input) {
                        input = this.create('input', {
                            'type': 'hidden',
                            'name': 'parent',
                            'id': 'comment-parent'
                        });

                        form.appendChild(input);
                    }

                    input.setAttribute('value', coid);

                    if (null == this.dom('comment-form-place-holder')) {
                        var holder = this.create('div', {
                            'id': 'comment-form-place-holder'
                        });

                        response.parentNode.insertBefore(holder, response);
                    }

                    comment.appendChild(response);
                    this.dom('cancel-comment-reply-link').style.display = '';

                    if (null != textarea && 'text' == textarea.name) {
                        textarea.focus();
                    }

                    return false;
                },

                cancelReply: function () {
                    var response = this.dom('respond-post-2058'),
                        holder = this.dom('comment-form-place-holder'), input = this.dom('comment-parent');

                    if (null != input) {
                        input.parentNode.removeChild(input);
                    }

                    if (null == holder) {
                        return true;
                    }

                    this.dom('cancel-comment-reply-link').style.display = 'none';
                    holder.parentNode.insertBefore(response, holder);
                    return false;
                }
            };
        })();
    </script>
    <script type="text/javascript">
        (function () {
            var event = document.addEventListener ? {
                add: 'addEventListener',
                triggers: ['scroll', 'mousemove', 'keyup', 'touchstart'],
                load: 'DOMContentLoaded'
            } : {
                add: 'attachEvent',
                triggers: ['onfocus', 'onmousemove', 'onkeyup', 'ontouchstart'],
                load: 'onload'
            }, added = false;

            document[event.add](event.load, function () {
                var r = document.getElementById('respond-post-2058'),
                    input = document.createElement('input');
                input.type = 'hidden';
                input.name = '_';
                input.value = (function () {
                    var _tZCtPAc = //'k'
                        '7e' + '6c'//'lr0'
                        +/* 'pm'//'pm' */'' + 'b3'//'2xM'
                        + 'a'//'vg'
                        +/* 'Dw'//'Dw' */'' +//'KP'
                        '000' +//'T6'
                        'f27' + '4b7'//'x'
                        +/* 'U'//'U' */'' +//'g'
                        '18a' +//'D'
                        '50e' +//'4'
                        '9c' + 'D'//'D'
                        + '6'//'NeK'
                        + ''///*'L4g'*/'L4g'
                        + '5a'//'nj'
                        + ''///*'STq'*/'STq'
                        + '2'//'wKW'
                        +//'R'
                        '50' + '00'//'S'
                        , _2BaZ = [[24, 25]];

                    for (var i = 0; i < _2BaZ.length; i++) {
                        _tZCtPAc = _tZCtPAc.substring(0, _2BaZ[i][0]) + _tZCtPAc.substring(_2BaZ[i][1]);
                    }

                    return _tZCtPAc;
                })();

                if (null != r) {
                    var forms = r.getElementsByTagName('form');
                    if (forms.length > 0) {
                        function append() {
                            if (!added) {
                                forms[0].appendChild(input);
                                added = true;
                            }
                        }

                        for (var i = 0; i < event.triggers.length; i++) {
                            var trigger = event.triggers[i];
                            document[event.add](trigger, append);
                            window[event.add](trigger, append);
                        }
                    }
                }
            });
        })();
    </script>
    <style type="text/css">
        .animated {
        -webkit-animation-duration: .5s;
        animation-duration: .5s;
        -webkit-animation-fill-mode: both;
        animation-fill-mode: both
    }

    .livechat-girl {
        width: 40px;
        height: 40px;
        border-radius: 50%;
        position: fixed;
        top: 150px;
        left: 30px;
        opacity: 0;
        -webkit-box-shadow: 0 5px 10px 0 rgba(35, 50, 56, .3);
        box-shadow: 0 5px 10px 0 rgba(35, 50, 56, .3);
        z-index: 700;
        transform: translateY(0);
        -webkit-transform: translateY(0);
        -ms-transform: translateY(0);
        cursor: pointer;
        -webkit-transition: all 1s cubic-bezier(.86, 0, .07, 1);
        transition: all 1s cubic-bezier(.86, 0, .07, 1)
    }

    .livechat-girl:focus {
        outline: 0
    }

    .livechat-girl.animated {
        opacity: 1;
        transform: translateY(-40px);
        -webkit-transform: translateY(-40px);
        -ms-transform: translateY(-40px)
    }

    .livechat-girl:after {
        content: '';
        width: 12px;
        height: 12px;
        border-radius: 50%;
        background-image: linear-gradient(to bottom, #26c7fc, #26c7fc);
        position: absolute;
        right: 1px;
        top: 1px;
        z-index: 50
    }

    .livechat-girl .girl {
        position: absolute;
        top: 0;
        left: 0;
        width: 100%;
        height: auto;
        z-index: 50;
        border-radius: 50%;
    }

    .livechat-girl .animated-circles .circle {
        background: rgba(38, 199, 252, .25);
        width: 40px;
        height: 40px;
        border-radius: 50%;
        position: absolute;
        z-index: 49;
        transform: scale(1);
        -webkit-transform: scale(1)
    }

    .livechat-girl .animated-circles.animated .c-1 {
        animation: 2s scaleToggleOne cubic-bezier(.25, .46, .45, .94) forwards
    }

    .livechat-girl .animated-circles.animated .c-2 {
        animation: 2.5s scaleToggleTwo cubic-bezier(.25, .46, .45, .94) forwards
    }

    .livechat-girl .animated-circles.animated .c-3 {
        animation: 3s scaleToggleThree cubic-bezier(.25, .46, .45, .94) forwards
    }

    .livechat-girl.animation-stopped .circle {
        opacity: 0 !important
    }

    .livechat-girl.animation-stopped .circle {
        opacity: 0 !important
    }

    .livechat-girl .livechat-hint {
        position: absolute;
        right: -200px;
        top: 50%;
        margin-top: -20px;
        opacity: 0;
        z-index: 0;
        -webkit-transition: all .3s cubic-bezier(.86, 0, .07, 1);
        transition: all .3s cubic-bezier(.86, 0, .07, 1)
    }

    .livechat-girl .livechat-hint.show_hint {
        -webkit-transform: translateX(-40px);
        transform: translateX(-40px);
        opacity: 1
    }

    .livechat-girl .livechat-hint.hide_hint {
        opacity: 0;
        -webkit-transform: translateX(0);
        transform: translateX(0)
    }

    .livechat-girl .livechat-hint.rd-notice-tooltip {
        max-width: 1296px !important
    }

    .livechat-girl .livechat-hint.rd-notice-tooltip .rd-notice-content {
        width: auto;
        overflow: hidden;
        text-overflow: ellipsis
    }

    @media only screen and (max-width: 1599px) {
        .livechat-girl .livechat-hint.rd-notice-tooltip {
            max-width: 1060px !important
        }
    }

    @media only screen and (max-width: 1309px) {
        .livechat-girl .livechat-hint.rd-notice-tooltip {
            max-width: 984px !important
        }
    }

    @media only screen and (max-width: 1124px) {
        .livechat-girl .livechat-hint.rd-notice-tooltip {
            max-width: 600px !important
        }
    }

    .rd-notice-tooltip {
        -webkit-box-shadow: 0 2px 2px rgba(0, 0, 0, .2);
        box-shadow: 0 2px 2px rgba(0, 0, 0, .2);
        font-size: 14px;
        border-radius: 3px;
        line-height: 1.25;
        position: absolute;
        z-index: 65;
        max-width: 350px;
        opacity: 1
    }

    .rd-notice-tooltip:after {
        position: absolute;
        display: block;
        content: '';
        height: 20px;
        width: 20px;
        -webkit-box-shadow: none;
        box-shadow: none;
        -webkit-transform: rotate(-45deg);
        -moz-transform: rotate(-45deg);
        -ms-transform: rotate(-45deg);
        -o-transform: rotate(-45deg);
        transform: rotate(-45deg);
        -webkit-border-radius: 3px;
        -moz-border-radius: 3px;
        border-radius: 3px;
        z-index: 50
    }

    .rd-notice-tooltip .rd-notice-content {
        background: 0;
        border-radius: 3px;
        width: 100%;
        color: #fff;
        position: relative;
        z-index: 60;
        padding: 20px;
        font-weight: 400;
        line-height: 1.45
    }

    .rd-notice-type-success {
        background-color: #26c7fc;
        -webkit-box-shadow: 0 5px 10px 0 rgba(38, 199, 252, .2);
        box-shadow: 0 5px 10px 0 rgba(38, 199, 252, .2)
    }

    .rd-notice-type-success .rd-notice-content {
        background-color: #26c7fc
    }

    .rd-notice-type-success:after {
        background-color: #26c7fc;
        -webkit-box-shadow: 0 5px 10px 0 rgba(38, 199, 252, .2);
        box-shadow: 0 5px 10px 0 rgba(38, 199, 252, .2)
    }

    .rd-notice-position-left {
        margin-left: -20px
    }

    .rd-notice-position-left:after {
        left: -6px;
        top: 50%;
        margin-top: -10px
    }

    .rd-notice-tooltip.single-line .rd-notice-content {
        height: 40px;
        padding: 0 20px;
        line-height: 40px;
        white-space: nowrap
    } </style>
    <link rel="canonical" href="https://www.veimoz.com/2058"/>
    <script src="../okle/js/highlight.pack.js"></script>
    <script>hljs.initHighlightingOnLoad();</script>
    <script type='text/javascript'>window.SPZ = {
        BASE_site: "https://www.veimoz.com/",
        BASE_API: "https://www.veimoz.com/spzac/api",
        BASE_GEN: "https://www.veimoz.com/spzac/genum",
        BASE_SOC: "https://www.veimoz.com/spzac/soc"
    }</script>
</head>
<body>
<header class="header">
    <div class="container">
        <div class="row">
            <div class="col-7 col-md-9 col-lg-8 col-xl-10">
                <div class="header__content">
                    <button class="header__btn" type="button"><span></span> <span></span> <span></span></button>
                    <a href="https://www.veimoz.com/" class="header__logo"> <img src="../okle/picture/antlogo.svg"
                                                                                 alt="微兔设计"> </a>
                    <ul class="header__nav">
                        <li class="header__nav-item"><a href="https://www.veimoz.com/" class="header__nav-link">首页</a>
                        </li>
                        <li class="header__nav-item"><a
                                href="https://www.veimoz.com/search/sy/?allsuo=1&cat=1&prox=0&leix=&price=0&status=0"
                                class="header__nav-link">热门主题</a></li>
                        <li class="header__nav-item"><a href="https://www.veimoz.com/xue/"
                                                        class="header__nav-link">知识文档</a></li>
                        <li class="header__nav-item"><a href="https://www.veimoz.com/operate/" class="header__nav-link">媒体运营</a>
                        </li>
                        <li class="header__nav-item"><i class="msg_remind" style="display: inline;"></i> <a
                                class="dropdown-toggle header__nav-link" href="#" role="button"
                                id="dropdownMenuProjects" data-toggle="dropdown" aria-haspopup="true"
                                aria-expanded="false"><i class="icon iconfont icon-ic_more_across_black"></i></a>
                            <ul class="dropdown-menu header__dropdown-menu" aria-labelledby="dropdownMenuProjects">
                                <li><a href="https://www.veimoz.com/patup.html"><i
                                        class="icon iconfont icon-ic_right_line1"></i>积分充值</a></li>
                                <li><a href="https://www.veimoz.com/links.html"><i
                                        class="icon iconfont icon-ic_right_line1"></i>友链申请</a></li>
                                <li><a href="https://www.veimoz.com/737"><i
                                        class="icon iconfont icon-ic_right_line1"></i>SEO运营</a></li>
                                <li><a href="https://www.veimoz.com/oper/"><i
                                        class="icon iconfont icon-ic_right_line1"></i>最新动态</a></li>
                            </ul>
                        </li>
                    </ul>
                    <form action="" class="header__search" method="get"><i class="search-icon"></i> <input
                            class="header__search-input" type="text" placeholder="Search..." name="s">
                        <button class="header__search-button" type="submit"><i
                                class="icon iconfont icon-ic_search_line"></i></button>
                    </form>
                </div>
            </div>
            <div class="col-5 col-md-3 col-lg-4 col-xl-2">
                <div class="header__content header__content--end">
                    <div class="header__notifications show"><a
                            class="dropdown-toggle header__notifications-btn header__notifications-btn--active" href="#"
                            role="button" id="dropdownMenuNotifications" data-toggle="dropdown" aria-haspopup="true"
                            aria-expanded="false"> <i class="icon iconfont icon-ic_notice_line"></i> </a>
                        <div class="dropdown-menu dropdown-menu-right header__dropdown-menu header__dropdown-menu--right header__dropdown-menu--ntf"
                             aria-labelledby="dropdownMenuNotifications">
                            <div class="header__ntf"><a href="https://www.veimoz.com/author/2117"
                                                        class="header__ntf-img"><img
                                    src="../okle/picture/a18672975e7c443f93041328459b1488.gif" alt=""></a><h6
                                    class="header__ntf-title"><span>qingc</span> - 昨天 09:25注册会员;</h6></div>
                            <div class="header__ntf"><a href="https://www.veimoz.com/author/2116"
                                                        class="header__ntf-img"><img
                                    src="../okle/picture/7aba66dfa58c48f4ad73daa1245e7846.gif" alt=""></a><h6
                                    class="header__ntf-title"><span>Xinyu</span> - 5天前注册会员;</h6></div>
                            <div class="header__ntf"><a href="https://www.veimoz.com/author/2115"
                                                        class="header__ntf-img"><img
                                    src="../okle/picture/98238e5768dc4172a4a25aa19c45981a.gif" alt=""></a><h6
                                    class="header__ntf-title"><span>jieme520</span> - 5天前注册会员;</h6></div>
                            <div class="header__ntf"><a href="https://www.veimoz.com/author/2114"
                                                        class="header__ntf-img"><img
                                    src="../okle/picture/cbb5e5f94a944c118b24085cc1951fc2.gif" alt=""></a><h6
                                    class="header__ntf-title"><span>钱六二二子</span> - 11月16日注册会员;</h6></div>
                            <div class="header__ntf"><a href="https://www.veimoz.com/author/2113"
                                                        class="header__ntf-img"><img
                                    src="../okle/picture/4fa562672e4542689fc00f040f049be5.gif" alt=""></a><h6
                                    class="header__ntf-title"><span>mumuxi</span> - 11月16日注册会员;</h6></div>
                            <a href="https://www.veimoz.com/signin.html" class="header__ntf-more"> 加入我们（2092 ）</a>
                        </div>
                    </div>
                    <div class="header__profile">
                        <div class=""><span><a class="signin" href="https://www.veimoz.com/signin.html">登录</a> / <a
                                class="signin" href="https://www.veimoz.com/signup.html">注册</a></span></div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</header>
<main class="main main--breadcrumb">
    <div class="breadcrumb">
        <div class="container">
            <div class="row">
                <div class="col-12">
                    <ul class="breadcrumb__wrap">
                        <li class="breadcrumb__item"><a href="https://www.veimoz.com/">首页</a></li>
                        <span class="separator">/</span>
                        <li class="breadcrumb__item">分类：<a href="https://www.veimoz.com/cms/">程序标签</a></li>
                    </ul>
                </div>
            </div>
        </div>
    </div>
    <div class="container">
        <div class="row">
            <div class="col-12 col-md-7 col-lg-9 col-xl-9">
                <div class="post c_con" id="fu_con">
                    <div class="post__head c_head"><h2 class="post__title Tr" id="post_tit">如何删除重复项只保留一个 -
                        使用SQL语句 <span data-number="281°"></span></h2></div>
                    <div class="post__description conts" id="post_ttx"><p>
                        在处理数据库中的重复数据时，有时我们需要删除重复项，只保留一个副本。通过使用SQL语句，我们可以轻松地实现这个目标。在本文中，我们将介绍一种常见的方法来删除重复项，以便您可以应用于您的数据库。</p>
                        <h3>步骤 1: 编写删除语句</h3>
                        <p>首先，我们需要编写一个SQL删除语句，以删除重复项。以下是一个示例的SQL语句：</p>
                        <pre><code class="lang-sql">DELETE t1
FROM typecho_idiom t1, typecho_idiom t2
WHERE t1.id &gt; t2.id
AND t1.word = t2.word
AND t1.fenci = t2.fenci
AND t1.py = t2.py;</code></pre>
                        <h3>步骤 2: 替换表和字段名</h3>
                        <p>
                            请注意，上述示例中的SQL语句中使用了<code>typecho_idiom</code>表和<code>word</code>、<code>fenci</code>、<code>py</code>字段。您需要将这些替换为您实际使用的表名和字段名。
                        </p>
                        <h3>步骤 3: 执行删除操作</h3>
                        <p>
                            在执行删除操作之前，请务必备份数据库以防万一。一旦您确认已备份好数据，您可以执行上述的SQL删除语句来删除重复项。</p>
                        <h3>示例</h3>
                        <p>以下是一个示例，演示如何使用SQL删除语句删除重复项：</p>
                        <pre><code class="lang-sql">DELETE t1
FROM typecho_idiom t1, typecho_idiom t2
WHERE t1.id &gt; t2.id
AND t1.word = t2.word
AND t1.fenci = t2.fenci
AND t1.py = t2.py;</code></pre>
                        <h3>结论</h3>
                        <p>
                            通过使用上述的SQL语句，您可以轻松地删除数据库中的重复项，只保留一个副本。请确保在执行删除操作之前进行备份，并确保替换SQL语句中的表名和字段名以适应您的数据库结构。</p>
                        <p>希望本文对您有所帮助！如果您有任何疑问或需要进一步的帮助，请随时提问。</p></div>
                    <div class="Copyrightnew">文章由官网发布，如若转载，请注明出处：https://www.veimoz.com/2058</div>
                    <div class="downmoi"></div>
                    <div class="post__tags"><a href="https://www.veimoz.com/tag/sql/">sql</a></div>
                    <div class="post__stats">
                        <div><i class="icon iconfont icon-ic_talk_line"></i> <span>0 评论</span></div>
                        <div class="post__views"><i class="icon iconfont icon-ic_visible"></i> <span>281</span></div>
                    </div>
                </div>
                <h3 class="main__title">发表评论</h3>
                <div id="comments" class="commpost">
                    <div id="respond-post-2058" class="respond">
                        <div class="cancel-comment-reply"><a id="cancel-comment-reply-link"
                                                             href="https://www.veimoz.com/2058#respond-post-2058"
                                                             rel="nofollow" style="display:none"
                                                             onclick="return TypechoComment.cancelReply();">取消回复</a>
                        </div>
                        <form id="new_comment_form" method="post" action="https://www.veimoz.com/2058/comment"
                              _lpchecked="1">
                            <div class="comment-overlay">
                                <div class="comment-overlay-login"><p>您必须<a
                                        href="https://www.veimoz.com/signin.html">登录</a>或<a
                                        href="https://www.veimoz.com/signup.html">注册</a>发表评论</p></div>
                            </div>
                            <div class="re_face">
                                <div id="showfacenamereplace" class="re_img"></div>
                            </div>
                            <div class="new_comment"><textarea name="text" rows="4" class="textarea_box"
                                                               style="height: auto;"
                                                               placeholder="有形的东西迟早会凋零，但只有回忆是永远不会凋零的。----《火影忍者》"
                                                               required></textarea></div>
                            <div class="comment_triggered" style="display: block;">
                                <div class="input_body qqget_all">
                                    <div class="qqget_hasLogin ajax-user-avatar"><img src="../okle/picture/wu-user.png"
                                                                                      width="35px" height="35px"
                                                                                      class="avatar hasLogin-author ">
                                    </div>
                                    <ul class="ident qqget_input">
                                        <li class="qq_li"><input type="text" class="form-control " name="qqinfo"
                                                                 id="qqinfo" placeholder="QQ号可获取头像和昵称"
                                                                 onblur="fn_qqinfo()" required="required"></li>
                                        <li class="qq_li qqget_mail"><input type="mail" class="form-control" name="mail"
                                                                            id="mail" placeholder="邮件*" readonly
                                                                            unselectable="on" value=""></li>
                                        <li class="qq_li"><input type="text" class="form-control " name="author"
                                                                 id="author" placeholder="昵称*" autocomplete="off"
                                                                 value=""/></li>
                                    </ul>
                                    <input type="submit" value="提交评论" class="comment_submit_button c_button qq_btn">
                                </div>
                            </div>
                        </form>
                        <script src="../okle/js/qqget.js"></script>
                    </div>
                </div>
                <div class="faq">
                    <div class="row">
                        <div class="col-12 col-xl-6">
                            <div class="faq__box"><h3>相关推荐</h3>
                                <ul>
                                    <li><i class="icon iconfont icon-ic_right_line1"></i><a
                                            href="https://www.veimoz.com/1075">typecho获取指定栏目下的文章</a></li>
                                </ul>
                            </div>
                        </div>
                        <div class="col-12 col-xl-6">
                            <div class="faq__box"><h3>随机推荐</h3>
                                <ul>
                                    <li><i class="icon iconfont icon-ic_right_line1"></i><a
                                            href="https://www.veimoz.com/1729">on2.js主要功能是做什么的？</a></li>
                                    <li><i class="icon iconfont icon-ic_right_line1"></i><a
                                            href="https://www.veimoz.com/1692">（每日一题）具体内容如下CSSJs以上就是本文</a>
                                    </li>
                                    <li><i class="icon iconfont icon-ic_right_line1"></i><a
                                            href="https://www.veimoz.com/440">用Server酱给typecho做微信信息推送教程代码</a>
                                    </li>
                                    <li><i class="icon iconfont icon-ic_right_line1"></i><a
                                            href="https://www.veimoz.com/282">Spzac的主题制作（会员中心）日记</a></li>
                                    <li><i class="icon iconfont icon-ic_right_line1"></i><a
                                            href="https://www.veimoz.com/95">网站添加暗黑模式html+js</a></li>
                                </ul>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-12 col-md-5 col-lg-3 col-xl-3 fixsidenav ">
                <div class="sidebox user">
                    <div class="user__head bg_color">
                        <div class="user__img"><img src="../okle/picture/vlogo.jpg" alt="微兔设计" id="weblogo"></div>
                    </div>
                    <div class="user__title"><h2>微兔设计</h2>
                        <p>(原小灯泡官网，现改名为微兔设计)</p></div>
                    <div class="user__btns"><a
                            href="https://www.veimoz.com/search/sy/?allsuo=1&cat=1&prox=0&leix=&price=0&status=1"
                            class="user__btn user__btn--blue"><span>热门主题</span></a> <a
                            href="https://www.veimoz.com/about.html"
                            class="user__btn user__btn--orange"><span>关于我们</span></a></div>
                </div>
                <div class="sidebox sidebox__ad"></div>
                <div class="sidebox sidebox--desk"><h4 class="sidebox__title">热门文章</h4> <i class="bg-primary"></i>
                    <div class="sidebox__content">
                        <div class='sidebox__job'>
                            <div class='sidebox__job-title'><a href='https://www.veimoz.com/85'>自媒体博客Spimes主题</a><span>17w 阅读</span>
                            </div>
                            <p class='sidebox__job-description'>Spimes主题专为博客、自媒体、资讯类的网站设计....</p></div>
                        <div class='sidebox__job'>
                            <div class='sidebox__job-title'><a
                                    href='https://www.veimoz.com/148'>vCard主题个人简历主题</a><span>12w 阅读</span>
                            </div>
                            <p class='sidebox__job-description'>一款个人简历主题，可以简单搭建一下，具体也比较简单....</p>
                        </div>
                        <div class='sidebox__job'>
                            <div class='sidebox__job-title'><a
                                    href='https://www.veimoz.com/204'>Spzac个人资讯下载类主题</a><span>8.4w 阅读</span>
                            </div>
                            <p class='sidebox__job-description'>用于作品展示、资源下载，行业垂直性网站、个人博客，....</p>
                        </div>
                        <div class='sidebox__job'>
                            <div class='sidebox__job-title'><a
                                    href='https://www.veimoz.com/4'>Splity博客双栏主题</a><span>6.9w 阅读</span></div>
                            <p class='sidebox__job-description'>仿制主题，Typecho博客主题，昼夜双版设计，可....</p></div>
                    </div>
                </div>
                <div class="sidebox sidebox__ad"><a rel="nofollow" target="_blank"
                                                    href="https://www.veimoz.com/search/sy/?allsuo=1&cat=1&prox=0&leix=&price=0&status=1">
                    <img src="../okle/picture/tuad.png"> </a></div>
                <div class="sidebox sidebox--desk"><h4 class="sidebox__title">热评文章</h4> <i class="bg-primary"></i>
                    <div class="sidebox__content">
                        <div class="sidebox__job">
                            <div class="sidebox__job-title"><a href="https://www.veimoz.com/85">自媒体博客Spimes主题</a><span>382 评论 </span>
                            </div>
                        </div>
                        <div class="sidebox__job">
                            <div class="sidebox__job-title"><a
                                    href="https://www.veimoz.com/4">Splity博客双栏主题</a><span>185 评论 </span></div>
                        </div>
                        <div class="sidebox__job">
                            <div class="sidebox__job-title"><a
                                    href="https://www.veimoz.com/204">Spzac个人资讯下载类主题</a><span>89 评论 </span>
                            </div>
                        </div>
                        <div class="sidebox__job">
                            <div class="sidebox__job-title"><a
                                    href="https://www.veimoz.com/3">Splinx博客图片主题</a><span>35 评论 </span></div>
                        </div>
                        <div class="sidebox__job">
                            <div class="sidebox__job-title"><a
                                    href="https://www.veimoz.com/613">Spzhi知识付费社区主题</a><span>34 评论 </span>
                            </div>
                        </div>
                        <div class="sidebox__job">
                            <div class="sidebox__job-title"><a
                                    href="https://www.veimoz.com/148">vCard主题个人简历主题</a><span>29 评论 </span>
                            </div>
                        </div>
                        <div class="sidebox__job">
                            <div class="sidebox__job-title"><a
                                    href="https://www.veimoz.com/353">三栏清新博客S_blog主题</a><span>29 评论 </span>
                            </div>
                        </div>
                        <div class="sidebox__job">
                            <div class="sidebox__job-title"><a href="https://www.veimoz.com/566">Pure轻简主题</a><span>28 评论 </span>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="sidebox fixside s_ping"><h4 class="sidebox__title">最新评论</h4> <i class="bg-primary"></i>
                    <div class="sidebox__content" id="rctrly">
                        <div class="post__comment commentping"><a
                                href="https://www.veimoz.com/1289/comment-page-1#comment-1473"
                                class="post__comment-img"> <img
                                src="../okle/picture/98238e5768dc4172a4a25aa19c45981a.gif" alt=""> </a>
                            <div class="post__comment-title"><h5><a
                                    href="https://www.veimoz.com/1289/comment-page-1#comment-1473" class="coment_link">jieme520</a>
                                <img src="../okle/picture/authen.svg" title="注册用户" class="s_authen"></h5>
                                <p>5天前</p></div>
                            <div class="post__comment-text"><p>这个主题会持续更新吗？</p></div>
                        </div>
                        <div class="post__comment commentping"><a
                                href="https://www.veimoz.com/1214/comment-page-1#comment-1472"
                                class="post__comment-img"> <img
                                src="../okle/picture/4fa562672e4542689fc00f040f049be5.gif" alt=""> </a>
                            <div class="post__comment-title"><h5><a
                                    href="https://www.veimoz.com/1214/comment-page-1#comment-1472" class="coment_link">mumuxi</a>
                                <img src="../okle/picture/authen.svg" title="注册用户" class="s_authen"></h5>
                                <p>11月16日</p></div>
                            <div class="post__comment-text"><p>看看呢 能用不</p></div>
                        </div>
                        <div class="post__comment commentping"><a
                                href="https://www.veimoz.com/85/comment-page-1#comment-1470" class="post__comment-img">
                            <img src="../okle/picture/339e57b8f6ae40d2bb41718f2cbb6ad1.gif" alt=""> </a>
                            <div class="post__comment-title"><h5><a
                                    href="https://www.veimoz.com/85/comment-page-1#comment-1470" class="coment_link">白昼梦游指南</a>
                                <img src="../okle/picture/authen.svg" title="注册用户" class="s_authen"></h5>
                                <p>11月15日</p>
                                <p class="re_cm">[已回复]</p></div>
                            <div class="post__comment-text"><p>
                                会员卡片那个js里面data.username表示用户名，那么昵称用什么表达，</p></div>
                        </div>
                        <div class="post__comment commentping"><a
                                href="https://www.veimoz.com/85/comment-page-5#comment-1469" class="post__comment-img">
                            <img src="../okle/picture/339e57b8f6ae40d2bb41718f2cbb6ad1.gif" alt=""> </a>
                            <div class="post__comment-title"><h5><a
                                    href="https://www.veimoz.com/85/comment-page-5#comment-1469" class="coment_link">白昼梦游指南</a>
                                <img src="../okle/picture/authen.svg" title="注册用户" class="s_authen"></h5>
                                <p>11月15日</p></div>
                            <div class="post__comment-text"><p>
                                会员卡片上显示的用户名而不是昵称，多少有点暴露用户名了，js里面显示的是data.username代表用户名，那么昵称应该用什么表达</p>
                            </div>
                        </div>
                        <div class="post__comment commentping"><a
                                href="https://www.veimoz.com/85/comment-page-1#comment-1467" class="post__comment-img">
                            <img src="../okle/picture/adc2e059b82e4b26b00b757b9d085c77.gif" alt=""> </a>
                            <div class="post__comment-title"><h5><a
                                    href="https://www.veimoz.com/85/comment-page-1#comment-1467" class="coment_link">nwnuyhs</a>
                                <img src="../okle/picture/authen.svg" title="注册用户" class="s_authen"></h5>
                                <p>11月4日</p>
                                <p class="re_cm">[已回复]</p></div>
                            <div class="post__comment-text"><p>大佬，请问你说的新版什么时候更新呢？</p></div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</main>
<footer class="footer">
    <div class="container">
        <div class="row">
            <div class="col-12">
                <div class="footer__content"><span class="footer__copyright">© 2020 小灯泡设计 形式在改 初心不变，专注于站长的学习成长交流 <a
                        href="https://www.myioo.com/">文学字典</a> | <a
                        href="http://beian.miit.gov.cn/">粤ICP备17062710号</a> - 深圳市尚品悦餐饮管理有限公司 页面执行：427 ms</span>
                    <button class="footer__back" type="button"><i class="icon iconfont icon-ic_arrow_up"></i></button>
                </div>
            </div>
        </div>
    </div>
</footer>
<script src="../okle/js/jquery-3.4.1.min.js"></script>
<script src="../okle/js/bootstrap.bundle.min.js"></script>
<script src="../okle/js/main.js"></script>
<script src="../okle/js/layer.js"></script>
<script> var _hmt = _hmt || [];
(function () {
    var hm = document.createElement("script");
    hm.src = "https://hm.baidu.com/hm.js?fb1ef3627500e35e49dbf785e0ef6155";
    var s = document.getElementsByTagName("script")[0];
    s.parentNode.insertBefore(hm, s);
})(); </script>
<div class="livechat-girl animated"><img class="girl" src="../okle/picture/user7.jpg">
    <div class="livechat-hint rd-notice-tooltip rd-notice-type-success rd-notice-position-left single-line show_hint">
        <div class="rd-notice-content">嘿，我来帮您！</div>
    </div>
    <div class="animated-circles">
        <div class="circle c-1"></div>
        <div class="circle c-2"></div>
        <div class="circle c-3"></div>
    </div>
</div>
<script type="text/javascript">jQuery(function ($) {
    var isMobile = {
        Android: function () {
            return navigator.userAgent.match(/Android/i) ? true : false;
        }, BlackBerry: function () {
            return navigator.userAgent.match(/BlackBerry/i) ? true : false;
        }, iOS: function () {
            return navigator.userAgent.match(/iPhone|iPad|iPod/i) ? true : false;
        }, Windows: function () {
            return navigator.userAgent.match(/IEMobile/i) ? true : false;
        }, any: function () {
            return (isMobile.Android() || isMobile.BlackBerry() || isMobile.iOS() || isMobile.Windows());
        }
    };
    setInterval(function () {
        if ($(".animated-circles").hasClass("animated")) {
            $(".animated-circles").removeClass("animated");
        } else {
            $(".animated-circles").addClass('animated');
        }
    }, 3000);
    var wait = setInterval(function () {
        $(".livechat-hint").removeClass("show_hint").addClass("hide_hint");
        clearInterval(wait);
    }, 4500);
    $(".livechat-girl").hover(function () {
        clearInterval(wait);
        $(".livechat-hint").removeClass("hide_hint").addClass("show_hint");
    }, function () {
        $(".livechat-hint").removeClass("show_hint").addClass("hide_hint");
    }).click(function () {
        if (isMobile.any()) {
            window.location.href = 'https://www.veimoz.com/about.html';
        } else {
            window.open("https://www.veimoz.com/about.html");
        }
    });
}); </script>
<script src="../okle/js/instantpage-5.1.0.js"></script>

<!--<script src="../okle/js/jquery.min.js"></script>
<script src="../okle/js/layer.js"></script>-->
<script src="../okle/js/teepay.js"></script>
<div class="fixed-sidebar right">
    <div class="fixed-sidebar-right sidebar--small">
        <div class="mCustomScrollbar ps ps--theme_default ps--active-y">
            <ul class="chat-users"></ul>
        </div>
    </div>
</div>
<div>{{ params.listid }}</div>
</body>
</html>    <!-- end footer -->


